Steps to create database, download SQL file and execute query to create tables and populate data. 6

            1. How to create database in SQL? 

 i .  Open your SQL Server Management Studio

    a. Click on Start button/ window icon on left bottom corner of your screen 

    b. Find Microsoft SQL Server Management Studio and click it.

    c.  Provide your server name ( if already not selected ) and click connect.



  ii. Create Database

    a. Right clicks on Database

    b. Click on New Database

    c. Write Database Name e.g. (DataWarehouse)

    d. Click Ok

    e. Refresh the database.



iii.       How to download the Sql file?

           a.    Click on the  Red Icon  on the top of the page to download the data File.


            b.  Extract the file once the download is complete by clicking on the Downloaded folder on the left bottom corner (Status bar) or go to folder location and open it,  Automatically Opens  in SQL Server Management  Studio. 

       Or,

                                 you have access to basecamp:

a.       Go to basecamp (https://3.basecamp.com/3945211/projects)

b.       Click on internship program

c.       Then click on Doc’s & file

d.       Click on Project files

e.       Click on Zendesk file

f.        Then click on Zendesk in Tableau

g.       Then click on Download Zendesk Data Mart. Sql


1.  

x

R       Run  the SQL script ( Follow the Previous steps (iii.  b & c)



A     After creating database and tables , table automatically loaded data.



A


A

a



Steps to create database, download SQL file and execute query to create tables and populate data. 6

            1. How to create database in SQL? 

 i .  Open your SQL Server Management Studio

    a. Click on Start button/ window icon on left bottom corner of your screen 

    b. Find Microsoft SQL Server Management Studio and click it.

    c.  Provide your server name ( if already not selected ) and click connect.



  ii. Create Database

    a. Right clicks on Database

    b. Click on New Database

    c. Write Database Name e.g. (DataWarehouse)

    d. Click Ok

    e. Refresh the database.



iii.       How to download the Sql file?

           a.    Click on the  Red Icon  on the top of the page to download the data File.


            b.  Extract the file once the download is complete by clicking on the Downloaded folder on the left bottom corner (Status bar) or go to folder location and open it,  Automatically Opens  in SQL Server Management  Studio. 

       Or,

                                 you have access to basecamp:

a.       Go to basecamp (https://3.basecamp.com/3945211/projects)

b.       Click on internship program

c.       Then click on Doc’s & file

d.       Click on Project files

e.       Click on Zendesk file

f.        Then click on Zendesk in Tableau

g.       Then click on Download Zendesk Data Mart. Sql


1.  

x

R       Run  the SQL script ( Follow the Previous steps (iii.  b & c)



A     After creating database and tables , table automatically loaded data.



A


A

a